CREATE FUNCTION [dbo].[asi_IsColumnIdentity](@tableName varchar(100), @columnName nvarchar(100))
RETURNS bit
AS
BEGIN
      -- Declare the return variable here
      DECLARE @Result bit;
      IF EXISTS (SELECT 1
                   FROM INFORMATION_SCHEMA.COLUMNS
                  WHERE COLUMNPROPERTY(OBJECT_ID(QUOTENAME([TABLE_SCHEMA]) + '.' + QUOTENAME([TABLE_NAME])), [COLUMN_NAME], 'IsIdentity') = 1
                        AND [TABLE_NAME] = @tableName and [COLUMN_NAME] = @columnName)
            SET @Result = 1
      ELSE
            SET @Result = 0
      RETURN @Result;
END


GO
GRANT EXECUTE ON  [dbo].[asi_IsColumnIdentity] TO [IMIS]
GO